{smcl}
{txt}{sf}{ul off}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/03_Logs/20221006_raw_to_importable.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res} 6 Oct 2022, 20:16:28
{txt}
{com}. 
. ***** March 2018 SUSENAS ******
. 
. *** Import blok 41 data
. import dbase using "$raw_dbf/Susenas 2018 Maret_full/Susenas Mar 2018 MKP/data/blok41_gab_prop11-33_diseminasi.dbf", clear
{res}{text}(25 vars, 6,991,792 obs)

{com}. tempfile b41prop11_33
{txt}
{com}. save `b41prop11_33'
{txt}{p 0 4 2}
file {bf}
C:\Users\suh958\AppData\Local\Temp\ST_63bc_000001.tmp{rm}
saved
as .dta format
{p_end}

{com}. import dbase using "$raw_dbf/Susenas 2018 Maret_full/Susenas Mar 2018 MKP/data/blok41_gab_prop34-94_diseminasi.dbf", clear
{res}{text}(25 vars, 7,098,948 obs)

{com}. append using `b41prop11_33'
{txt}
{com}. save "${c -(}importable{c )-}/blok41_gab_prop11-94_mar_18.dta" , replace
{txt}{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/blok41_gab_prop11-94_mar_18.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/blok41_gab_prop11-94_mar_18.dta{rm}
saved
{p_end}

{com}. 
. *** Import blok 42 data
. import dbase using "$raw_dbf/Susenas 2018 Maret_full/Susenas Mar 2018 MKP/data/blok42.dbf", clear
{res}{text}(22 vars, 11,860,966 obs)

{com}. save "$importable/blok42_mar_18.dta", replace
{txt}{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/blok42_mar_18.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/blok42_mar_18.dta{rm}
saved
{p_end}

{com}. 
. *** Import blok43 data
. import dbase using "$raw_dbf/Susenas 2018 Maret_full/Susenas Mar 2018 MKP/data/blok43.dbf", clear
{res}{text}(19 vars, 295,155 obs)

{com}. save "${c -(}importable{c )-}/blok43_mar_18.dta" , replace
{txt}{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/blok43_mar_18.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/blok43_mar_18.dta{rm}
saved
{p_end}

{com}. 
. *** Import household module data
. cd "$raw_dbf/Susenas 2018 Maret_full/Susenas Mar 2018 KOR/Data Mikro Survei Sosial Ekonomi Nasional 2018 Maret (KOR)"
{res}C:\Users\suh958\Dropbox (Harvard University)\J-PAL Raskin Transition\10_Analysis&Results\BPNT_AEA_data_code\01_Data\00_Raw_DBF\Susenas 2018 Maret_full\Susenas Mar 2018 KOR\Data Mikro Survei Sosial Ekonomi Nasional 2018 Maret (KOR)
{txt}
{com}. import dbase "kor18rt_diseminasi.dbf", clear
{res}{text}(181 vars, 295,155 obs)

{com}. // import dbase "$raw_dbf/Susenas 2018 Maret_full/Susenas Mar 2018 KOR/Data Mikro Survei Sosial Ekonomi Nasional 2018 Maret (KOR)/kor18rt_diseminasi.dbf", clear
. save "${c -(}importable{c )-}/kor18rt_diseminasi.dta", replace
{txt}{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/kor18rt_diseminasi.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/kor18rt_diseminasi.dta{rm}
saved
{p_end}

{com}. 
. *** Import individual module data
. // import dbase "kor18ind_revisi_diseminasi.dbf", clear
. import dbase "kor18ind_diseminasi.dbf", clear
{res}{text}(178 vars, 1,131,825 obs)

{com}. // import dbase "$raw_dbf/Susenas 2018 Maret_full/Susenas Mar 2018 KOR/Data Mikro Survei Sosial Ekonomi Nasional 2018 Maret (KOR)/kor18ind_revisi_diseminasi.dbf", clear
. save "${c -(}importable{c )-}/kor18ind_diseminasi.dta", replace
{txt}{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/kor18ind_diseminasi.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/kor18ind_diseminasi.dta{rm}
saved
{p_end}

{com}. 
. 
. ***** September 2018 SUSENAS *****
. /*
> *** Import individual module data
> cd "$sep_2018_susenas_ind_hh"
> import dbase "msbp18ind_diseminasi.dbf", clear
> save "$importable/msbp18ind_diseminasi.dta", replace
> 
> *** Import household module data
> import dbase "msbp18rt_diseminasi.dbf", clear
> save "$importable/msbp18rt_diseminasi.dta", replace
> 
> *** Import blok 41 data
> cd "$sep_2018_susenas_cons"
> import dbase "blok41_gab_diseminasi.dbf", clear
> save "$importable/blok41_gab_diseminasi_sep_18.dta", replace
> 
> *** Import blok 42 data
> cd "$sep_2018_susenas_cons"
> import dbase "blok42_diseminasi.dbf", clear
> save "$importable/blok42_diseminasi_sep_18.dta", replace
> 
> *** Import blok 43 data
> import dbase "blok43_diseminasi.dbf", clear
> save "$importable/blok43_diseminasi_sep_18.dta", replace
> */
. 
. ***** March 2019 SUSENAS *****
. 
. *** Ind
. import dbase "$raw_dbf/SUSENAS Mar 2019/From Bu Vivi Jan 2020/KOR Individu/kor19ind_2_dds.dbf", clear
{res}{text}(204 vars, 1,204,466 obs)

{com}. tempfile kor19ind2
{txt}
{com}. save `kor19ind2'
{txt}{p 0 4 2}
file {bf}
C:\Users\suh958\AppData\Local\Temp\ST_63bc_000002.tmp{rm}
saved
as .dta format
{p_end}

{com}. import dbase "$raw_dbf/SUSENAS Mar 2019/From Bu Vivi Jan 2020/KOR Individu/kor19ind_1_dds.dbf", clear
{res}{text}(110 vars, 1,204,466 obs)

{com}. merge 1:1 RENUM R401 using `kor19ind2', assert(3)
{res}
{txt}{col 5}Result{col 33}Number of obs
{col 5}{hline 41}
{col 5}Not matched{col 30}{res}               0
{txt}{col 5}Matched{col 30}{res}       1,204,466{txt}  (_merge==3)
{col 5}{hline 41}

{com}. drop _m
{txt}
{com}. 
. save "$importable/kor19ind.dta", replace
{txt}{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/kor19ind.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/kor19ind.dta{rm}
saved
{p_end}

{com}. 
. *** RT
. import dbase "$raw_dbf/SUSENAS Mar 2019/From Bu Vivi Jan 2020/kor19rt_dds.dbf", clear
{res}{text}(180 vars, 315,672 obs)

{com}. save "$importable/kor19rt.dta", replace
{txt}{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/kor19rt.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/kor19rt.dta{rm}
saved
{p_end}

{com}. 
. *** Blok 41
. import dbase "$raw_dbf/SUSENAS Mar 2019/From Bu Vivi Jan 2020/KP blok 41/blok41_gab_31_36_dds.dbf", clear
{res}{text}(24 vars, 5,126,008 obs)

{com}. tempfile b41_31_36
{txt}
{com}. save `b41_31_36'
{txt}{p 0 4 2}
file {bf}
C:\Users\suh958\AppData\Local\Temp\ST_63bc_000003.tmp{rm}
saved
as .dta format
{p_end}

{com}. import dbase "$raw_dbf/SUSENAS Mar 2019/From Bu Vivi Jan 2020/KP blok 41/blok41_gab_51_94_dds.dbf", clear
{res}{text}(24 vars, 5,737,751 obs)

{com}. tempfile b41_51_94
{txt}
{com}. save `b41_51_94'
{txt}{p 0 4 2}
file {bf}
C:\Users\suh958\AppData\Local\Temp\ST_63bc_000004.tmp{rm}
saved
as .dta format
{p_end}

{com}. import dbase "$raw_dbf/SUSENAS Mar 2019/From Bu Vivi Jan 2020/KP blok 41/blok41_gab_11_21_dds.dbf", clear
{res}{text}(24 vars, 4,408,125 obs)

{com}. append using `b41_31_36'
{txt}
{com}. append using `b41_51_94'
{txt}{p 0 7 2}
(variable
{bf:B41K8} was {bf:long}, now {bf:double} to accommodate using data's values)
{p_end}

{com}. save "$importable/blok41_mar19.dta", replace
{txt}{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/blok41_mar19.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/blok41_mar19.dta{rm}
saved
{p_end}

{com}. 
. *** Blok 42
. import dbase "$raw_dbf/SUSENAS Mar 2019/From Bu Vivi Jan 2020/KP blok 42/blok42_31_36_dds.dbf", clear
{res}{text}(22 vars, 4,176,157 obs)

{com}. tempfile b42_31_36
{txt}
{com}. save `b42_31_36'
{txt}{p 0 4 2}
file {bf}
C:\Users\suh958\AppData\Local\Temp\ST_63bc_000005.tmp{rm}
saved
as .dta format
{p_end}

{com}. import dbase "$raw_dbf/SUSENAS Mar 2019/From Bu Vivi Jan 2020/KP blok 42/blok42_51_94_dds.dbf", clear
{res}{text}(22 vars, 5,157,597 obs)

{com}. tempfile b42_51_94
{txt}
{com}. save `b42_51_94'
{txt}{p 0 4 2}
file {bf}
C:\Users\suh958\AppData\Local\Temp\ST_63bc_000006.tmp{rm}
saved
as .dta format
{p_end}

{com}. import dbase "$raw_dbf/SUSENAS Mar 2019/From Bu Vivi Jan 2020/KP blok 42/blok42_11_21_dds.dbf", clear
{res}{text}(22 vars, 3,701,254 obs)

{com}. append using `b42_31_36'
{txt}
{com}. append using `b42_51_94'
{txt}
{com}. save "$importable/blok42_mar19.dta", replace
{txt}{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/blok42_mar19.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/blok42_mar19.dta{rm}
saved
{p_end}

{com}. 
. *** Blok 43
. import dbase "$raw_dbf/SUSENAS Mar 2019/From Bu Vivi Jan 2020/blok43_dds.dbf", clear
{res}{text}(18 vars, 315,672 obs)

{com}. save "$importable/blok43_mar19.dta", replace
{txt}{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/blok43_mar19.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/blok43_mar19.dta{rm}
saved
{p_end}

{com}. 
. *** Import PODES 2018 data
. forvalues num = 1 / 4 {c -(}
{txt}  2{com}.   import dbase "$raw_dbf/PODES DESA/podes2018_desa_part`num'_revisi.dbf", clear
{txt}  3{com}.   save "$importable/podes2018_desa_part`num'_revisi.dta", replace
{txt}  4{com}. {c )-}
{res}{text}(149 vars, 83,931 obs)
{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/podes2018_desa_part1_revisi.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/podes2018_desa_part1_revisi.dta{rm}
saved
{p_end}
{res}{text}(216 vars, 83,931 obs)
{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/podes2018_desa_part2_revisi.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/podes2018_desa_part2_revisi.dta{rm}
saved
{p_end}
{res}{text}(231 vars, 83,931 obs)
{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/podes2018_desa_part3_revisi.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/podes2018_desa_part3_revisi.dta{rm}
saved
{p_end}
{res}{text}(184 vars, 83,931 obs)
{p 0 4 2}
(file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/podes2018_desa_part4_revisi.dta{rm}
not found)
{p_end}
{p 0 4 2}
file {bf}
C:/Users/suh958/Dropbox (Harvard University)/J-PAL Raskin Transition/10_Analysis&Results/BPNT_AEA_data_code/01_Data/01_Importable/podes2018_desa_part4_revisi.dta{rm}
saved
{p_end}

{com}. 
. /*
> *** Import PODES 2019 data
> import dbase "$jpal_data/Podes/Podes 2019/DATA/podes_2019_b1b8.dbf", clear
> 
> preserve
> import dbase "$jpal_data/Podes/Podes 2019/DATA/podes_2019_b9b13.dbf", clear
> tempfile podes19
> qui save `podes19'
> restore
> 
> merge 1:1 R101 R102 R103 R104 using `podes19', nogen assert(3)
> 
> save "$importable/podes_2019_b1b13.dta", replace
> */
. 
. cap log close
{smcl}
{com}{sf}{ul off}